use stockfinder
go

select s.symbolid, s.name, jbo.baselength, jbo.basedepth,
ibd.composite, ibd.eps, ibd.rs, ibd.smr, ibd.accdist, ibd.grouprs,
jbo.LastPriceDate, jbo.BaseLowDate,jbo.BaseLowPrice,jbo.PreviousHighDate,
jbo.PreviousHighPrice
from dbo.JustBrokenOut jbo, dbo.Symbols s, dbo.IBDRating ibd
where jbo.symbolid = s.symbolid
and s.symbolid = ibd.symbolid
order by jbo.baselength, ibd.composite desc


